Kelly P. ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	28

About Me

About Me

Not much happening here, yet.

Analytics

140

Posts

233

Visits

9.2k

Points

Sep 29, 2020

Join Date

Nov 11, 2024

Last Active

Reactions

• Insightful 9

  9
• Vote Up 20

  20
• Awesome 31

  31

• Activity
• Discussions2
• Comments138

• Re: If Formula help

  Kelly P.

  10/09/24
  @Matt Johnson That's interesting; thank you for sharing! With a column name of "Total Assets", I assumed it to hold numbers, but adding the value function is a good safeguard.
  1 ·

• Re: Edit reports on a dashboard

  Kelly P.

  02/21/23
  @Marc Shecter One workaround that I have used in the past is to use the Web Content widget on the dashboard in conjunction with the embed code option in the publish settings of the sheet (edit by any…
  4 ·

• Re: Create a Column =Original sheet name ?

  Kelly P.

  08/06/24
  @Megan Finn You can easily populate the value using the Change Cell Value automation. When a new row is added, change the value in the "Source" column to the desired value. See help article…
  1 ·

• Re: How to trigger dropdown to populate projected completed date based on specific complexity?

  Kelly P.

  11/09/23
  @NBKD There is a slightly different formula: =IF(Complexity@row = "Low Complexity", WORKDAY([Record Date: Complexity]@row, 2), IF(Complexity@row = "Medium Complexity", WORKDAY([Re…
  1 ·

• Re: How to trigger dropdown to populate projected completed date based on specific complexity?

  Kelly P.

  11/08/23
  @NBKD Try this: =IF(Complexity@row = "Low Complexity", [Record Date: Complexity]@row + 2, IF(Complexity@row = "Medium Complexity", [Record Date: Complexity]@row + 5, IF(Complexity…
  1 ·

Next